<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
  <head>
    <META http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>SaproMobilieBD.sdf Database Schema</title>
    <meta http-equiv="content-type" content="text/html; charset=utf-8">
    <style type="text/css">
                    body { background-color: #fff; color: #000; font-family: Consolas, monospace}
                    a:link { color: #03d; }
                    a:visited { color: #039; }
                    a:hover { color: #09f; }
                    table { border-collapse: collapse; width: 100%; }
                    table caption { color: #666; text-align: right; font-size: 65%; margin-bottom: .5ex; }
                    table td, table th { border: solid 1px #666; border-collapse: collapse; padding: .3ex .5ex; vertical-align: top; }
                    table tbody tr:hover { background-color: #ffc; }
                    table thead th { text-align: left; background-color: #ccc; }
                    table tbody th { text-align: left; white-space: nowrap; }
                    .table { page-break-inside: avoid; }
                    .pk { float: right; cursor: arrow; color: #999; }
                    .type { white-space: nowrap; }
                    .null { text-align: center; }
                    .flag { white-space: nowrap; font-size: 70%; display: inline-block; border: solid 1px #ccc; padding: .25ex .5ex; background-color: #ddd; margin-right: 1ex; }
                    .tocref { float: right; text-decoration: none; font-weight: normal; }
                    .footer { text-align: center; margin-top: 1em; font-size: 80%;}
                    li.view:before { content: "VIEW"; font-size: 70%; display: inline-block; border: solid 1px #ccc; padding: .25ex .5ex; background-color: #ddd; margin-right: 1ex; }
                    @media print {
                    body { font-size: .8em; }
                    #toc, .tocref { display: none; }
                    a:link, a:visited { color: #000; text-decoration: none; }
                    }
                </style>
  </head>
  <body>
    <h1>SaproMobilieBD.sdf Database Schema</h1>
    <div id="toc">
      <ul>
        <li class="table"><a href="#Aluno">Aluno</a></li>
        <li class="table"><a href="#Ata">Ata</a></li>
        <li class="table"><a href="#Escola">Escola</a></li>
        <li class="table"><a href="#Materia">Materia</a></li>
        <li class="table"><a href="#Professor">Professor</a></li>
      </ul>
    </div>
    <div class="table">
      <h2 id=""><a href="#toc" class="tocref">⇧</a>
        Database Properties
      </h2>
      <table>
        <thead>
          <tr>
            <th>Property</th>
            <th>Value</th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <td class="type">locale identifier</td>
            <td class="type">1046</td>
          </tr>
          <tr>
            <td class="type">encryption mode</td>
            <td class="type">
            </td>
          </tr>
          <tr>
            <td class="type">case sensitive</td>
            <td class="type">False</td>
          </tr>
          <tr>
            <td class="type">Database</td>
            <td class="type">D:\Desenvolvimento\PROJETOS\PROCENGE\SaproMobilieBD.sdf</td>
          </tr>
          <tr>
            <td class="type">ServerVersion</td>
            <td class="type">3.5.8080.0</td>
          </tr>
          <tr>
            <td class="type">DatabaseSize</td>
            <td class="type">86016</td>
          </tr>
          <tr>
            <td class="type">Created</td>
            <td class="type">25/12/2012 19:48</td>
          </tr>
        </tbody>
      </table>
    </div>
    <div class="table">
      <h2 id="Aluno"><a href="#toc" class="tocref">⇧</a>Table Aluno</h2>
      <table>
        <thead>
          <tr>
            <th style="width:30ex">Name</th>
            <th style="width:20ex">Type</th>
            <th style="width:4ex">NULL</th>
            <th>Comment</th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <th>nome_alun</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>presenca</th>
            <td class="type">bit</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th><span class="pk" title="PRIMARY KEY PK__Aluno__000000000000008E">◆</span>matricula_alun</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>codigo_ata</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td><span class="flag" title="FK__Aluno__0000000000000093">⇨ <a href="#Ata">Ata</a>.codigo_ata</span></td>
          </tr>
          <tr>
            <th>codigo_mat</th>
            <td class="type">nvarchar (5)</td>
            <td class="null">☐</td>
            <td><span class="flag" title="FK__Aluno__0000000000000097">⇨ <a href="#Materia">Materia</a>.codigo_mat</span></td>
          </tr>
        </tbody>
      </table>
    </div>
    <div class="table">
      <h2 id="Ata"><a href="#toc" class="tocref">⇧</a>Table Ata</h2>
      <table>
        <thead>
          <tr>
            <th style="width:30ex">Name</th>
            <th style="width:20ex">Type</th>
            <th style="width:4ex">NULL</th>
            <th>Comment</th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <th>data</th>
            <td class="type">datetime</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th><span class="pk" title="PRIMARY KEY PK__Ata__000000000000007A">◆</span>codigo_ata</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>codigo_mat</th>
            <td class="type">nvarchar (5)</td>
            <td class="null">☐</td>
            <td><span class="flag" title="FK__Ata__000000000000007F">⇨ <a href="#Materia">Materia</a>.codigo_mat</span></td>
          </tr>
        </tbody>
      </table>
    </div>
    <div class="table">
      <h2 id="Escola"><a href="#toc" class="tocref">⇧</a>Table Escola</h2>
      <table>
        <thead>
          <tr>
            <th style="width:30ex">Name</th>
            <th style="width:20ex">Type</th>
            <th style="width:4ex">NULL</th>
            <th>Comment</th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <th><span class="pk" title="PRIMARY KEY PK__Escola__0000000000000056">◆</span>nome_esc</th>
            <td class="type">nvarchar (40)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>telefone</th>
            <td class="type">nvarchar (9)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>numero</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>rua</th>
            <td class="type">nvarchar (50)</td>
            <td class="null">☒</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>estado</th>
            <td class="type">nvarchar (20)</td>
            <td class="null">☒</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>pais</th>
            <td class="type">nvarchar (20)</td>
            <td class="null">☒</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>cep</th>
            <td class="type">nvarchar (9)</td>
            <td class="null">☒</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>matricula_prof</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td><span class="flag" title="FK__Escola__000000000000005B">⇨ <a href="#Professor">Professor</a>.matricula_prof</span></td>
          </tr>
        </tbody>
      </table>
    </div>
    <div class="table">
      <h2 id="Materia"><a href="#toc" class="tocref">⇧</a>Table Materia</h2>
      <table>
        <thead>
          <tr>
            <th style="width:30ex">Name</th>
            <th style="width:20ex">Type</th>
            <th style="width:4ex">NULL</th>
            <th>Comment</th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <th><span class="pk" title="PRIMARY KEY PK__Materia__000000000000006A">◆</span>codigo_mat</th>
            <td class="type">nvarchar (5)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>nome_mat</th>
            <td class="type">nvarchar (20)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>turma</th>
            <td class="type">nvarchar (10)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>descricao</th>
            <td class="type">nvarchar (50)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>nome_escola</th>
            <td class="type">nvarchar (40)</td>
            <td class="null">☐</td>
            <td><span class="flag" title="FK__Materia__000000000000006F">⇨ <a href="#Escola">Escola</a>.nome_esc</span></td>
          </tr>
        </tbody>
      </table>
    </div>
    <div class="table">
      <h2 id="Professor"><a href="#toc" class="tocref">⇧</a>Table Professor</h2>
      <table>
        <thead>
          <tr>
            <th style="width:30ex">Name</th>
            <th style="width:20ex">Type</th>
            <th style="width:4ex">NULL</th>
            <th>Comment</th>
          </tr>
        </thead>
        <tbody>
          <tr>
            <th><span class="pk" title="PRIMARY KEY PK__Professor__0000000000000040">◆</span>matricula_prof</th>
            <td class="type">int</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>nome_prof</th>
            <td class="type">nvarchar (30)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
          <tr>
            <th>email</th>
            <td class="type">nvarchar (50)</td>
            <td class="null">☐</td>
            <td>
            </td>
          </tr>
        </tbody>
      </table>
    </div>
    <div class="footer">
                    Generated by <a href="http://SqlDbDoc.codeplex.com/">DB&gt;doc</a> and <a href="http://sqlcetoolbox.codeplex.com/">SQL Server Compact Toolbox</a> on
                    December 27, 2012, 21:45:36</div>
  </body>
</html>